UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQ+379M9JSXwbHguQSmA9tpqqPDekn4nL0B0iyfyYC0='
WHERE
key_id = '3e4e76018ae18d0a462eb5562d2fe09056e369f39994278c73cd4e7628dfaa4b'
AND (
token = 'XQ+379M9JSXwbHguQSmA9tpqqPDekn4nL0B0iyfyYC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)