UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FIrEtsoMus0ZB9AcN/HQa/X180opYSH8M3XfX/h13VM='
WHERE
key_id = 'd402db5abf526aa160df270cee43cbcd5cba9fd23315632439e3afc360b2a428'
AND (
token = 'FIrEtsoMus0ZB9AcN/HQa/X180opYSH8M3XfX/h13VM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)