UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oWYJoxDyitFqOTwh8POYCjA4h2BBta/GK1rIG4C+noI='
WHERE
key_id = 'a9629f234f9bb430cfd5c19f5e10a1a3b5a1f43eea0bd465c276026cb783ebc3'
AND (
token = 'oWYJoxDyitFqOTwh8POYCjA4h2BBta/GK1rIG4C+noI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)