UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ocFivPfnw3e5P5W5SdzqBQz9CmmzGN5bdV498+OpF60='
WHERE
key_id = '27ce50557549d78c88eb0bc14728e2b3d709cccdb6881c981ae26d9df3bf3a0f'
AND (
token = 'ocFivPfnw3e5P5W5SdzqBQz9CmmzGN5bdV498+OpF60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)