UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ctIllQRhZ6hiLKjnXDzc8msp7EoTBefOcJyjcMC+iDM='
WHERE
key_id = '7ed75437e1cde6517bd9ef70058fae6ff22b59dfe9e6303416581294ea482a50'
AND (
token = 'ctIllQRhZ6hiLKjnXDzc8msp7EoTBefOcJyjcMC+iDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)