UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qG5awMF/DC/Xq45ow5PR2N5oaDwUfXqzfpwudgz+lGI=' 
WHERE 
  key_id = '8d7d0cd939d6f3b46657b351c2e091c452a7bd5d1096e0b998f1fe23d5d7ce0a' 
  AND (
    token = 'qG5awMF/DC/Xq45ow5PR2N5oaDwUfXqzfpwudgz+lGI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036