UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ff4TKthXJM8T4u6NA2s7gQzRC6eeh+CbUXl3WJfC0Ew=' 
WHERE 
  key_id = '649879c7b9b5ac2dc303be6fd64da68e88b5b5047596df85f75221fd1b4f64f8' 
  AND (
    token = 'ff4TKthXJM8T4u6NA2s7gQzRC6eeh+CbUXl3WJfC0Ew=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018