UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n06OeNkSF6gqzAR/jI/U47+XMDDlRgSgVkHPA9nJGns='
WHERE
key_id = 'b25f28d74e90a3330cd6a1de770d410241661ce3e67adab74aa62ed03f2e57e1'
AND (
token = 'n06OeNkSF6gqzAR/jI/U47+XMDDlRgSgVkHPA9nJGns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)