UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hA8JG45XIb38tJcVmEgdUutcr4d5IJyLXZBEwFTRTD0='
WHERE
key_id = 'aca74761b63cd558038414fd0ff06cb3ef1b5c3cde4cbc2fd6b0d198550d3dc2'
AND (
token = 'hA8JG45XIb38tJcVmEgdUutcr4d5IJyLXZBEwFTRTD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)