UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G1R5i3ZANBeleVj6uKu0wWd2eoZzGChSKn6FSwmyovY='
WHERE
key_id = '40e84880ef5b6aaf3f90f35d8535aee1f8f2610244a61bd858ad273bc4e2a947'
AND (
token = 'G1R5i3ZANBeleVj6uKu0wWd2eoZzGChSKn6FSwmyovY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)