UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tQ9DjBT695GpOt61dx5fcyybbB5wHFcHO9nR5J3tOt0=' 
WHERE 
  key_id = 'bc1e8d753869dd93535cedf0cab4acbb0abedb2a4985f5750d81c387f14ce074' 
  AND (
    token = 'tQ9DjBT695GpOt61dx5fcyybbB5wHFcHO9nR5J3tOt0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038