UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WSJ0ScnMyVfOdJIpEctyUxEhoavFpoPoB7ln8Trvtq4='
WHERE
key_id = '0ce42f0891c813edeeffabdc0a4f94ebfe3b5060e77dc9001d8cb4812af91b26'
AND (
token = 'WSJ0ScnMyVfOdJIpEctyUxEhoavFpoPoB7ln8Trvtq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)