UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wmFBa9pBVAVxiRgAd29+qQZh3Jt1VxNJqtTZ2Gxf7M='
WHERE
key_id = '685a03fe06a9306f607e59cd3931d4173c0a100afaf34e8d638e0c1ef9cd3ec0'
AND (
token = '8wmFBa9pBVAVxiRgAd29+qQZh3Jt1VxNJqtTZ2Gxf7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)