UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mDTeHpU4t11LJnc+TbJfRQVQi/Fx4q3qoERoIJZdgWA=' 
WHERE 
  key_id = '1a543a6c2512e62af6c7185c061ae18b74a6a6d060abb8647bdd9b7d2b026218' 
  AND (
    token = 'mDTeHpU4t11LJnc+TbJfRQVQi/Fx4q3qoERoIJZdgWA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026