UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zStFo6j3PfhdMPu6Pqg0LGxyYgaYSdmajlelZIA6J94='
WHERE
key_id = '2f826d13190f758bada4a6901086f9d71f1cbf4e442548185990052dc54ec36a'
AND (
token = 'zStFo6j3PfhdMPu6Pqg0LGxyYgaYSdmajlelZIA6J94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)