UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VcO3mH1oih4u3F/mO4hhGY2YnyAHSFZOfpBY8Gy/Zng='
WHERE
key_id = 'b3ac1617638ce392a0d5e4232a67934261e0a35dc40897dbc6959b14d4605a3a'
AND (
token = 'VcO3mH1oih4u3F/mO4hhGY2YnyAHSFZOfpBY8Gy/Zng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)