UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnfgZb1v0KnqwfKHJRvSXTSHistbr37SXm9mTYniMC8='
WHERE
key_id = '20d16aa325b2364a4d3825a090739d516a123646d54ffa310557f87077013a09'
AND (
token = 'CnfgZb1v0KnqwfKHJRvSXTSHistbr37SXm9mTYniMC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)