UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XhbbMmaYh86+DcodY10kVm7185UHqMFRapTavI0auQY='
WHERE
key_id = 'dc2bf171dd1cb1dce9913a41e32f93a710ba453a2e0dae2e42d02de74561b9aa'
AND (
token = 'XhbbMmaYh86+DcodY10kVm7185UHqMFRapTavI0auQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)