UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nZvX3E2bPfRixeC2EVwpI7BTP7BjUK9DkaPg8jQgask=' 
WHERE 
  key_id = '348f432cf6f9f842fdc00a5973b69e4fe62747d1c30ac6b9ce0e7ef84e4a19c3' 
  AND (
    token = 'nZvX3E2bPfRixeC2EVwpI7BTP7BjUK9DkaPg8jQgask=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027