UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZK1V2srcQ+0QyURdaFGbQgBy2AMQehtkYoVmcBAVWo='
WHERE
key_id = 'db680d2eea80cb960e5ca16de47d35e2f7b15098ac77b3b8b2f8a118e6ff7432'
AND (
token = 'hZK1V2srcQ+0QyURdaFGbQgBy2AMQehtkYoVmcBAVWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)