UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l8qR0tlQyekdvyxhg1JEWKdAUZcgZeCIRdDObvAcUxA='
WHERE
key_id = 'c80672a197aa0c9c2e132f8fd3be56e46279e4eda002204dd0829cc5c4f2b9a0'
AND (
token = 'l8qR0tlQyekdvyxhg1JEWKdAUZcgZeCIRdDObvAcUxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)