UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tBsLOHjjxybJH9Bc15eLdRvqFHFzg92EubllQG9STVs='
WHERE
key_id = 'bfc22c0252ac8a4036a34073fbe5a9687a1766b346da353535345c5f8e0878b7'
AND (
token = 'tBsLOHjjxybJH9Bc15eLdRvqFHFzg92EubllQG9STVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)