UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cNr7G+ih9L3l9JHNCF8yuV5ZnFnfSY6x+3kKgy9/8C4=' 
WHERE 
  key_id = '3a8f42612138ecb616966673dac29e302dadfe8e4f44c41e6e684d70068b4554' 
  AND (
    token = 'cNr7G+ih9L3l9JHNCF8yuV5ZnFnfSY6x+3kKgy9/8C4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039