UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XLDY9TQNJHMojw0JRI+woJtWsuEKdCS3OZq2ftatR4='
WHERE
key_id = 'e72ce510efbd4b760e022ddf0a5fa70d1b904b0bcac90491ffc99e80abc0039c'
AND (
token = '6XLDY9TQNJHMojw0JRI+woJtWsuEKdCS3OZq2ftatR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)