UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8L3miojS9csd/B8OHCrJ5xxcajZ4axgGGTlSLbH386c='
WHERE
key_id = 'ca5b1e6a61f7d4d9cfda9b18d5a4336df9df4769f153eb036b81d39597c35d47'
AND (
token = '8L3miojS9csd/B8OHCrJ5xxcajZ4axgGGTlSLbH386c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)