UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vO/NJThmRan1joRdax1aiOgL6cdYO6zXi6M5qVl1q/4=' 
WHERE 
  key_id = 'f5c1840d5705653f4a8b7a5268d13a060bc8f5e294f1ebf3a551874eb26fbe44' 
  AND (
    token = 'vO/NJThmRan1joRdax1aiOgL6cdYO6zXi6M5qVl1q/4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037