UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'otZKnvXkzV7Pu3JPjYkoZ8AkHUOP5Euq+1MNnDdygvg=' 
WHERE 
  key_id = '0705d46859ce4463aabf639abba3d5673372c917bd9e3f84ddbe9776b2c83c10' 
  AND (
    token = 'otZKnvXkzV7Pu3JPjYkoZ8AkHUOP5Euq+1MNnDdygvg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022