UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1sOj0tWs8VH2pt68HzVtA/gvka8SSRL9G6m6GjmVNc='
WHERE
key_id = 'd1bfa9b4a41049ae9fae005b499708cd1f5036903cac72eb5d9feb9559f2925c'
AND (
token = 'X1sOj0tWs8VH2pt68HzVtA/gvka8SSRL9G6m6GjmVNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)