UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hYj1WIN5W5Hp+B/26MznrvBjnMjjZvTAAKKcFao6KYo='
WHERE
key_id = 'c978e847dbd7bad880874e0069c7b77f72576948223e0750cf8df618e3347293'
AND (
token = 'hYj1WIN5W5Hp+B/26MznrvBjnMjjZvTAAKKcFao6KYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)