UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nnn6sY5xngQhstaSfnrlOmHZ/cL0haVIyZr2X0A0UJQ=' 
WHERE 
  key_id = '2b495bf91575a58aeed3383f20b6495c0b5a719952289266de46cef7a90e65e6' 
  AND (
    token = 'nnn6sY5xngQhstaSfnrlOmHZ/cL0haVIyZr2X0A0UJQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020