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