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