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