UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'orMWuJ80dsfdsckBx7xJ6dMivAo68kCXBLUUuVWC8LI='
WHERE
key_id = 'cff71f573c6b57183f160c84d5bd951ec7f0b5f1d5e84e727e95c4d290de59e8'
AND (
token = 'orMWuJ80dsfdsckBx7xJ6dMivAo68kCXBLUUuVWC8LI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)