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